package com.test.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.test.bean.Emp;

public interface EmpMapper {
	public List<Emp> getEmp();

	public Emp getEmpAndDept(Integer id);

	public Emp getEmpByIdStep(Integer id);

	public List<Emp> getEmpById(Integer id);

	public List<Emp> getEmpDiscriminator();

	public List<Emp> getEmpByIdAndName(@Param("id") Integer id, @Param("name") String name);

	public List<Emp> getEmpByNgolIf(@Param("id") Integer id, @Param("ename") String name);

	public List<Emp> getEmpByNgoltrim(@Param("id") Integer id, @Param("ename") String name, @Param("job") String job);

	public List<Emp> getEmpByNgolChoose(@Param("id") Integer id, @Param("ename") String name);

	public int updateEmpBySet(Emp emp);

	public List<Emp> getEmpByIn(List<Integer> ids);

	public int saveMySql1Emps(@Param("emps") List<Emp> emps);

	public int saveMySql2Emps(@Param("emps") List<Emp> emps);
	
	public int saveOracle1Emps(@Param("emps") List<Emp> emps);
	
	public List<Emp> getEmpsTestInnerParam(Emp emp);

}
